Specifies fields to display in the Matchlists module when potential matching records between two databases are found.
DescriptionMost Vital Records Offices perform table cross-matching, particularly between Births and Deaths so that a Birth certificate can have a deceased endorsement printed on it when the person has died. Table cross-matching first attempts to find an exact matching record and, failing that, to find records that potentially match. This entry specifies which fields from each table to show the operator processing the matches to assist them in determining whether there is a match.
Usage
This Registry entry is assigned to groups:
| Key | Group |
|---|---|
| Key 1 | Group |
| Key 2 | Default |
| Key 3 | Table |
| Key 4 | ematchlist |
| Key 5 | Match Pair |
| Key 6 | table1-table2 |
| Value | format |
In pipe-delimited format:Group | Default | Table | ematchlist | Match Pair | table1-table2 | format |
where:
table1-table2 | specifies the two tables that are to be cross-matched. |
format | is made up of two halves, each half defining the link field within the table, and formatting to display its fields on-screen. If table1 is ebirths, the first half of format must be for ebirths columns. The format of each half is as follows:
The two halves are divided by a hash (#). The format uses printf style formatting. |
Example
This entry specifies the fields to be displayed for Birth to Death cross-matching (and vice versa). Note that in the Births table the link fields is DeathRegistrationRef and in the Deaths database it is BirthRegistrationRef:
| Key | Setting |
|---|---|
| Key 1 | Group |
| Key 2 | Default |
| Key 3 | Table |
| Key 4 | ematchlists |
| Key 5 | Match Pair |
| Key 6 | ebirths-edeaths |
| Value | DeathRegistrationRef;ChildGivenNames=[Birth Registration]\r\nName: %s;ChildSurname= %s\r\n;ChildDateOfBirth=D.O.B.: %s\r\n;FatherSurname=Father's Surname: %s\r\n;MotherMaidenSurname=Mother's Maiden Name: %s#BirthRegistrationRef;DeceasedGivenNames=[Death Registration]\r\nName: %s;DeceasedSurname= %s\r\n;DeceasedDateOfBirth=D.O.B.: %s\r\n;DeceasedDateOfDeath=D.O.D.: %s\r\n;LegacyAgeInYears=Age at Death: %s\r\n;FatherSurname=Father's Surname: %s\r\n;MotherMaidenSurname=Mother's Maiden Name: %s |